INSERT INTO regions VALUES('0','Africa');
INSERT INTO regions VALUES('1','Americas');
INSERT INTO regions VALUES('2','Asia-Pacific');
INSERT INTO regions VALUES('3','Europe');
INSERT INTO regions VALUES('4','Middle East');
INSERT INTO regions VALUES('5','North America');
INSERT INTO regions VALUES('6','South America');
INSERT INTO regions VALUES('7','South Asia');

INSERT INTO countries VALUES(1,'Afghanistan','7',652225,26000000,NULL);
INSERT INTO countries VALUES(2,'Albania','3',28728,3200000,6656000000);
INSERT INTO countries VALUES(3,'Algeria','4',2400000,32900000,75012000000);
INSERT INTO countries VALUES(4,'Andorra','3',468,64000,NULL);
INSERT INTO countries VALUES(5,'Angola','0',1250000,14500000,14935000000);
INSERT INTO countries VALUES(6,'Antigua and Barbuda','1',442,77000,770000000);
INSERT INTO countries VALUES(7,'Argentina','6',2800000,39300000,146196000000);
INSERT INTO countries VALUES(8,'Armenia','3',29743,3000000,3360000000);
INSERT INTO countries VALUES(9,'Australia','2',7700000,20300000,546070000000);
INSERT INTO countries VALUES(10,'Austria','3',83871,8100000,261630000000);
INSERT INTO countries VALUES(11,'Azerbaijan','3',86600,8500000,NULL);
INSERT INTO countries VALUES(12,'Bahamas','1',13939,321000,4789320000);
INSERT INTO countries VALUES(13,'Bahrain','4',717,754000,9357140000);
INSERT INTO countries VALUES(14,'Bangladesh','7',143998,152600000,67144000000);
INSERT INTO countries VALUES(15,'Barbados','1',430,272000,2518720000);
INSERT INTO countries VALUES(16,'Belarus','3',207595,9800000,20776000000);
INSERT INTO countries VALUES(17,'Belgium','3',30528,10300000,319609000000);
INSERT INTO countries VALUES(18,'Belize','1',22965,266000,NULL);
INSERT INTO countries VALUES(19,'Benin','0',112622,7100000,3763000000);
INSERT INTO countries VALUES(20,'Bhutan','7',38364,2400000,1824000000);
INSERT INTO countries VALUES(21,'Bolivia','6',1100000,9100000,NULL);
INSERT INTO countries VALUES(22,'Bosnia-Hercegovina','3',51129,4200000,8568000000);
INSERT INTO countries VALUES(23,'Botswana','0',581730,1800000,7812000000);
INSERT INTO countries VALUES(24,'Brazil','6',8550000,182800000,564852000000);
INSERT INTO countries VALUES(25,'Brunei','2',5765,374000,NULL);
INSERT INTO countries VALUES(26,'Bulgaria','3',110994,7800000,21372000000);
INSERT INTO countries VALUES(27,'Burkina Faso','0',274200,13800000,4968000000);
INSERT INTO countries VALUES(28,'Burma','2',676552,50700000,NULL);
INSERT INTO countries VALUES(29,'Burundi','0',27816,7300000,NULL);
INSERT INTO countries VALUES(30,'Cambodia','2',181035,14800000,4736000000);
INSERT INTO countries VALUES(31,'Cameroon','0',465458,16600000,13280000000);
INSERT INTO countries VALUES(32,'Canada','5',9900000,32000000,908480000000);
INSERT INTO countries VALUES(33,'Cape Verde','0',4033,482000,853140000);
INSERT INTO countries VALUES(34,'Central African Republic','0',622984,3900000,NULL);
INSERT INTO countries VALUES(35,'Chad','0',1280000,9100000,2366000000);
INSERT INTO countries VALUES(36,'Chile','6',756096,16200000,79542000000);
INSERT INTO countries VALUES(37,'China','2',9600000,1300000000,1677000000000);
INSERT INTO countries VALUES(38,'Colombia','6',1140000,45600000,NULL);
INSERT INTO countries VALUES(39,'Comoros','0',1862,812000,NULL);
INSERT INTO countries VALUES(40,'Costa Rica','1',51100,4300000,NULL);
INSERT INTO countries VALUES(41,'Croatia','3',56594,4400000,28996000000);
INSERT INTO countries VALUES(42,'Cuba','1',110860,11300000,NULL);
INSERT INTO countries VALUES(43,'Cyprus','3',9250,807000,14187060000);
INSERT INTO countries VALUES(44,'Czech Republic','3',78866,10200000,93330000000);
INSERT INTO countries VALUES(45,'Democratic Republic of Congo','0',2340000,56000000,6720000000);
INSERT INTO countries VALUES(46,'Denmark','3',43098,5400000,219510000000);
INSERT INTO countries VALUES(47,'Djibouti','0',23200,721000,NULL);
INSERT INTO countries VALUES(48,'Dominica','1',751,71000,259150000);
INSERT INTO countries VALUES(49,'Dominican Republic','1',48072,9000000,NULL);
INSERT INTO countries VALUES(50,'East Timor','2',14609,857000,NULL);
INSERT INTO countries VALUES(51,'Ecuador','6',272045,13400000,NULL);
INSERT INTO countries VALUES(52,'Egypt','4',1000000,74900000,98119000000);
INSERT INTO countries VALUES(53,'El Salvador','1',21041,6700000,15745000000);
INSERT INTO countries VALUES(54,'Equatorial Guinea','0',28051,521000,484530000);
INSERT INTO countries VALUES(55,'Eritrea','0',117400,4561599,NULL);
INSERT INTO countries VALUES(56,'Estonia','3',45227,1300000,9113000000);
INSERT INTO countries VALUES(57,'Ethiopia','0',1130000,74200000,8162000000);
INSERT INTO countries VALUES(58,'Fiji','2',18376,854000,NULL);
INSERT INTO countries VALUES(59,'Finland','3',338145,5200000,170508000000);
INSERT INTO countries VALUES(60,'Former Yugoslav Republic of Macedonia','3',25713,2000000,4700000000);
INSERT INTO countries VALUES(61,'France','3',543965,60700000,1826463000000);
INSERT INTO countries VALUES(62,'Gabon','0',267667,1400000,NULL);
INSERT INTO countries VALUES(63,'Georgia','3',69700,5000000,5200000000);
INSERT INTO countries VALUES(64,'Germany','3',357027,82500000,2484900000000);
INSERT INTO countries VALUES(65,'Ghana','0',238533,21800000,8284000000);
INSERT INTO countries VALUES(66,'Greece','3',131957,11000000,182710000000);
INSERT INTO countries VALUES(67,'Grenada','1',344,103000,NULL);
INSERT INTO countries VALUES(68,'Guatemala','1',108890,13000000,NULL);
INSERT INTO countries VALUES(69,'Guinea','0',245857,8800000,4048000000);
INSERT INTO countries VALUES(70,'Guinea-Bissau','0',36125,1600000,256000000);
INSERT INTO countries VALUES(71,'Guyana','6',214969,768000,NULL);
INSERT INTO countries VALUES(72,'Haiti','1',27750,8500000,NULL);
INSERT INTO countries VALUES(73,'Honduras','1',112492,7200000,7416000000);
INSERT INTO countries VALUES(74,'Hungary','3',93030,9800000,81046000000);
INSERT INTO countries VALUES(75,'Iceland','3',103000,294000,11354280000);
INSERT INTO countries VALUES(76,'India','7',3100000,1100000000,682000000000);
INSERT INTO countries VALUES(77,'Indonesia','2',1900000,225300000,256842000000);
INSERT INTO countries VALUES(78,'Iran','4',1650000,70700000,162610000000);
INSERT INTO countries VALUES(79,'Iraq','4',438317,26500000,NULL);
INSERT INTO countries VALUES(80,'Ireland','3',70182,4000000,137120000000);
INSERT INTO countries VALUES(81,'Israel and Palestinian territories','4',20770,3800000,4256000000);
INSERT INTO countries VALUES(82,'Italy','3',301338,57200000,1494064000000);
INSERT INTO countries VALUES(83,'Ivory Coast','0',322462,17100000,13167000000);
INSERT INTO countries VALUES(84,'Jamaica','1',10991,2700000,7830000000);
INSERT INTO countries VALUES(85,'Japan','2',377864,127900000,4755322000000);
INSERT INTO countries VALUES(86,'Jordan','4',89342,5700000,12198000000);
INSERT INTO countries VALUES(87,'Kazakhstan','2',2700000,15400000,NULL);
INSERT INTO countries VALUES(88,'Kenya','0',582646,32800000,15088000000);
INSERT INTO countries VALUES(89,'Kiribati','2',810,85000,82450000);
INSERT INTO countries VALUES(90,'Kuwait','4',17818,2700000,48519000000);
INSERT INTO countries VALUES(91,'Kyrgyzstan','2',199900,5300000,NULL);
INSERT INTO countries VALUES(92,'Laos','2',236800,5900000,2301000000);
INSERT INTO countries VALUES(93,'Latvia','3',64589,2300000,NULL);
INSERT INTO countries VALUES(94,'Lebanon','4',10452,3800000,18924000000);
INSERT INTO countries VALUES(95,'Lesotho','0',30355,1800000,1332000000);
INSERT INTO countries VALUES(96,'Liberia','0',99067,3600000,396000000);
INSERT INTO countries VALUES(97,'Libya','0',1770000,5800000,25810000000);
INSERT INTO countries VALUES(98,'Liechtenstein','3',160,34000,NULL);
INSERT INTO countries VALUES(99,'Lithuania','3',65300,3400000,19516000000);
INSERT INTO countries VALUES(100,'Luxembourg','3',2586,465000,26146950000);
INSERT INTO countries VALUES(101,'Madagascar','0',587041,18400000,5520000000);
INSERT INTO countries VALUES(102,'Malawi','0',118484,12600000,2142000000);
INSERT INTO countries VALUES(103,'Malaysia','2',329847,25300000,NULL);
INSERT INTO countries VALUES(104,'Mali','0',1250000,13800000,4968000000);
INSERT INTO countries VALUES(105,'Malta','3',316,397000,4863250000);
INSERT INTO countries VALUES(106,'Marshall Islands','2',181,57000,135090000);
INSERT INTO countries VALUES(107,'Mauritania','4',1040000,3100000,1302000000);
INSERT INTO countries VALUES(108,'Mauritius','0',2040,1200000,5568000000);
INSERT INTO countries VALUES(109,'Mexico','5',1960000,106400000,720328000000);
INSERT INTO countries VALUES(110,'Micronesia','2',700,111000,NULL);
INSERT INTO countries VALUES(111,'Moldova','3',33800,4300000,3053000000);
INSERT INTO countries VALUES(112,'Monaco','3',2,32000,NULL);
INSERT INTO countries VALUES(113,'Mongolia','2',1560000,2700000,NULL);
INSERT INTO countries VALUES(114,'Morocco','4',710850,31600000,48032000000);
INSERT INTO countries VALUES(115,'Mozambique','0',812379,19500000,4875000000);
INSERT INTO countries VALUES(116,'Namibia','0',824292,2000000,4740000000);
INSERT INTO countries VALUES(117,'Nauru','2',21,9900,NULL);
INSERT INTO countries VALUES(118,'Nepal','7',147181,26300000,6838000000);
INSERT INTO countries VALUES(119,'New Zealand','2',270534,4000000,81240000000);
INSERT INTO countries VALUES(120,'Nicaragua','1',120254,5700000,4503000000);
INSERT INTO countries VALUES(121,'Niger','0',1270000,12900000,2967000000);
INSERT INTO countries VALUES(122,'Nigeria','0',923768,130200000,50778000000);
INSERT INTO countries VALUES(123,'North Korea','2',122762,22900000,NULL);
INSERT INTO countries VALUES(124,'Norway','3',323759,4600000,239338000000);
INSERT INTO countries VALUES(125,'Oman','4',309500,3000000,23670000000);
INSERT INTO countries VALUES(126,'Pakistan','7',796095,161100000,96660000000);
INSERT INTO countries VALUES(127,'Palau','2',508,20000,NULL);
INSERT INTO countries VALUES(128,'Panama','1',75517,3200000,NULL);
INSERT INTO countries VALUES(129,'Papua New Guinea','2',462840,5900000,3422000000);
INSERT INTO countries VALUES(130,'Paraguay','6',406752,6200000,NULL);
INSERT INTO countries VALUES(131,'Peru','6',1280000,28000000,NULL);
INSERT INTO countries VALUES(132,'Poland','3',312685,38500000,234465000000);
INSERT INTO countries VALUES(133,'Portugal','3',92345,10500000,150675000000);
INSERT INTO countries VALUES(134,'Qatar','4',11437,628000,NULL);
INSERT INTO countries VALUES(135,'Republic of Congo','0',342000,3039126,NULL);
INSERT INTO countries VALUES(136,'Romania','3',238391,22200000,64824000000);
INSERT INTO countries VALUES(137,'Russia','3',17000000,141500000,482515000000);
INSERT INTO countries VALUES(138,'Rwanda','0',26338,8600000,1892000000);
INSERT INTO countries VALUES(139,'Samoa','2',2831,182000,NULL);
INSERT INTO countries VALUES(140,'San Marino','3',61,27000,NULL);
INSERT INTO countries VALUES(141,'Sao Tome and Principe','0',1001,169000,62530000);
INSERT INTO countries VALUES(142,'Saudi Arabia','4',2240000,25600000,267008000000);
INSERT INTO countries VALUES(143,'Senegal','0',196722,10600000,7102000000);
INSERT INTO countries VALUES(144,'Serbia and Montenegro','3',102173,10500000,27510000000);
INSERT INTO countries VALUES(145,'Seychelles','0',455,76000,NULL);
INSERT INTO countries VALUES(146,'Sierra Leone','0',71740,5300000,1060000000);
INSERT INTO countries VALUES(147,'Singapore','2',660,4400000,106568000000);
INSERT INTO countries VALUES(148,'Slovakia','3',49033,5400000,34992000000);
INSERT INTO countries VALUES(149,'Slovenia','3',20273,2000000,29620000000);
INSERT INTO countries VALUES(150,'Solomon Islands','2',27556,504000,277200000);
INSERT INTO countries VALUES(151,'Somalia','0',637657,10700000,NULL);
INSERT INTO countries VALUES(152,'South Africa','0',1220000,45300000,164439000000);
INSERT INTO countries VALUES(153,'South Korea','2',99313,48200000,673836000000);
INSERT INTO countries VALUES(154,'Spain','3',505988,44100000,935361000000);
INSERT INTO countries VALUES(155,'Sri Lanka','7',65610,19400000,19594000000);
INSERT INTO countries VALUES(156,'St Kitts and Nevis','1',269,46000,NULL);
INSERT INTO countries VALUES(157,'St Lucia','1',616,152000,655120000);
INSERT INTO countries VALUES(158,'St Vincent and the Grenadines','1',389,121000,441650000);
INSERT INTO countries VALUES(159,'Sudan','4',2500000,35000000,18550000000);
INSERT INTO countries VALUES(160,'Surinam','6',163265,442000,NULL);
INSERT INTO countries VALUES(161,'Swaziland','0',17364,1100000,1826000000);
INSERT INTO countries VALUES(162,'Sweden','3',449964,8900000,318353000000);
INSERT INTO countries VALUES(163,'Switzerland','3',41284,7100000,342433000000);
INSERT INTO countries VALUES(164,'Syria','4',185180,18600000,22134000000);
INSERT INTO countries VALUES(165,'Taiwan','2',36188,22700000,302364000000);
INSERT INTO countries VALUES(166,'Tajikistan','2',143100,6300000,NULL);
INSERT INTO countries VALUES(167,'Tanzania','0',945087,38400000,NULL);
INSERT INTO countries VALUES(168,'Thailand','2',513115,64100000,162814000000);
INSERT INTO countries VALUES(169,'The Gambia','0',11295,1500000,NULL);
INSERT INTO countries VALUES(170,'The Maldives','7',298,338000,848380000);
INSERT INTO countries VALUES(171,'The Netherlands','3',41864,16300000,516710000000);
INSERT INTO countries VALUES(172,'The Philippines','2',300000,82800000,96876000000);
INSERT INTO countries VALUES(173,'Togo','0',56785,5100000,1938000000);
INSERT INTO countries VALUES(174,'Tonga','2',748,106000,NULL);
INSERT INTO countries VALUES(175,'Trinidad and Tobago','1',5128,1300000,NULL);
INSERT INTO countries VALUES(176,'Tunisia','4',164150,10000000,26300000000);
INSERT INTO countries VALUES(177,'Turkey','3',779452,73300000,274875000000);
INSERT INTO countries VALUES(178,'Turkmenistan','2',488100,5000000,NULL);
INSERT INTO countries VALUES(179,'Tuvalu','2',26,10000,NULL);
INSERT INTO countries VALUES(180,'Uganda','0',241038,27600000,7452000000);
INSERT INTO countries VALUES(181,'Ukraine','3',603700,47800000,60228000000);
INSERT INTO countries VALUES(182,'United Arab Emirates','4',77700,3100000,NULL);
INSERT INTO countries VALUES(183,'United Kingdom','3',242514,59600000,2022824000000);
INSERT INTO countries VALUES(184,'United States of America','5',9800000,295000000,12213000000000);
INSERT INTO countries VALUES(185,'Uruguay','6',176215,3500000,NULL);
INSERT INTO countries VALUES(186,'Uzbekistan','2',447400,26900000,NULL);
INSERT INTO countries VALUES(187,'Vanuatu','2',12190,222000,297480000);
INSERT INTO countries VALUES(188,'Vatican','3',0,NULL,NULL);
INSERT INTO countries VALUES(189,'Venezuela','6',881050,26600000,NULL);
INSERT INTO countries VALUES(190,'Vietnam','2',329247,83600000,45980000000);
INSERT INTO countries VALUES(191,'Yemen','4',536869,21500000,12255000000);
INSERT INTO countries VALUES(192,'Zambia','0',752614,11000000,4950000000);
INSERT INTO countries VALUES(193,'Zimbabwe','0',390759,12900000,6192000000);